Overview
Brought to you by YData
Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 14787 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.8 MiB |
| Average record size in memory | 200.0 B |
Variable types
| Text | 8 |
|---|---|
| DateTime | 1 |
| Categorical | 4 |
| Numeric | 12 |
actual_distance_to_destination is highly overall correlated with actual_time and 8 other fields | High correlation |
actual_time is highly overall correlated with actual_distance_to_destination and 7 other fields | High correlation |
dest_state is highly overall correlated with source_state | High correlation |
od_time_diff_hour is highly overall correlated with actual_distance_to_destination and 8 other fields | High correlation |
osrm_distance is highly overall correlated with actual_distance_to_destination and 8 other fields | High correlation |
osrm_time is highly overall correlated with actual_distance_to_destination and 8 other fields | High correlation |
route_type is highly overall correlated with actual_distance_to_destination and 5 other fields | High correlation |
segment_actual_time_sum is highly overall correlated with actual_distance_to_destination and 7 other fields | High correlation |
segment_osrm_distance_sum is highly overall correlated with actual_distance_to_destination and 7 other fields | High correlation |
segment_osrm_time_sum is highly overall correlated with actual_distance_to_destination and 8 other fields | High correlation |
source_state is highly overall correlated with dest_state | High correlation |
start_scan_to_end_scan is highly overall correlated with actual_distance_to_destination and 8 other fields | High correlation |
trip_day is highly overall correlated with trip_month | High correlation |
trip_month is highly overall correlated with trip_day | High correlation |
trip_uuid has unique values | Unique |
trip_creation_time has unique values | Unique |
od_time_diff_hour has unique values | Unique |
trip_hour has 991 (6.7%) zeros | Zeros |
trip_dayofweek has 1980 (13.4%) zeros | Zeros |
Reproduction
| Analysis started | 2025-04-24 17:19:51.037758 |
|---|---|
| Analysis finished | 2025-04-24 17:20:16.423801 |
| Duration | 25.39 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
trip_uuid
Text
Unique 
| Distinct | 14787 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
Length
| Max length | 24 |
|---|---|
| Median length | 23 |
| Mean length | 23.000744 |
| Min length | 23 |
Unique
| Unique | 14787 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | trip-153671041653548748 |
|---|---|
| 2nd row | trip-153671042288605164 |
| 3rd row | trip-153671043369099517 |
| 4th row | trip-153671046011330457 |
| 5th row | trip-153671052974046625 |
| Value | Count | Frequency (%) |
| trip-153671046011330457 | 1 | < 0.1% |
| trip-153861118270144424 | 1 | < 0.1% |
| trip-153671041653548748 | 1 | < 0.1% |
| trip-153861042148375909 | 1 | < 0.1% |
| trip-153861052318770017 | 1 | < 0.1% |
| trip-153861055072891350 | 1 | < 0.1% |
| trip-153861059679001096 | 1 | < 0.1% |
| trip-153861073259859847 | 1 | < 0.1% |
| trip-153861075467184898 | 1 | < 0.1% |
| trip-153861089403973335 | 1 | < 0.1% |
| Other values (14777) | 14777 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 35458 | |
| 3 | 35367 | |
| 1 | 35141 | |
| 7 | 28883 | 8.5% |
| 8 | 25138 | 7.4% |
| 6 | 22675 | 6.7% |
| 0 | 21072 | 6.2% |
| 9 | 20942 | 6.2% |
| 2 | 20831 | 6.1% |
| 4 | 20670 | 6.1% |
| Other values (5) | 73935 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 340112 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 5 | 35458 | |
| 3 | 35367 | |
| 1 | 35141 | |
| 7 | 28883 | 8.5% |
| 8 | 25138 | 7.4% |
| 6 | 22675 | 6.7% |
| 0 | 21072 | 6.2% |
| 9 | 20942 | 6.2% |
| 2 | 20831 | 6.1% |
| 4 | 20670 | 6.1% |
| Other values (5) | 73935 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 340112 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 5 | 35458 | |
| 3 | 35367 | |
| 1 | 35141 | |
| 7 | 28883 | 8.5% |
| 8 | 25138 | 7.4% |
| 6 | 22675 | 6.7% |
| 0 | 21072 | 6.2% |
| 9 | 20942 | 6.2% |
| 2 | 20831 | 6.1% |
| 4 | 20670 | 6.1% |
| Other values (5) | 73935 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 340112 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 5 | 35458 | |
| 3 | 35367 | |
| 1 | 35141 | |
| 7 | 28883 | 8.5% |
| 8 | 25138 | 7.4% |
| 6 | 22675 | 6.7% |
| 0 | 21072 | 6.2% |
| 9 | 20942 | 6.2% |
| 2 | 20831 | 6.1% |
| 4 | 20670 | 6.1% |
| Other values (5) | 73935 |
Unique 
| Distinct | 14787 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
| Minimum | 2018-09-12 00:00:16.535741 |
|---|---|
| Maximum | 2018-10-03 23:59:42.701692 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 1497 |
|---|---|
| Distinct (%) | 10.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
Length
| Max length | 51 |
|---|---|
| Median length | 51 |
| Mean length | 51 |
| Min length | 51 |
Unique
| Unique | 160 ? |
|---|---|
| Unique (%) | 1.1% |
Sample
| 1st row | thanos::sroute:d7c989ba-a29b-4a0b-b2f4-288cdc60074b |
|---|---|
| 2nd row | thanos::sroute:3a1b0ab2-bb0b-4c53-8c59-eb2a2c0d68b9 |
| 3rd row | thanos::sroute:de5e208e-7641-45e6-8100-4d9fb1e5720d |
| 4th row | thanos::sroute:f0176492-a679-4597-8332-bbd1c7f9f442 |
| 5th row | thanos::sroute:d9f07b12-65e0-4f3b-bec8-df0613461b0f |
| Value | Count | Frequency (%) |
| thanos::sroute:a16bfa03-3462-4bce-9c82-5784c7d315e6 | 53 | 0.4% |
| thanos::sroute:8e6cd941-adb5-4f66-b44f-84938f5fca03 | 46 | 0.3% |
| thanos::sroute:c736b86f-5c1d-4497-832c-876db4c1a518 | 43 | 0.3% |
| thanos::sroute:ca336899-47aa-4622-9885-b9fbb2302aeb | 41 | 0.3% |
| thanos::sroute:5f8fb6cf-814a-426f-b2c9-8665b605d343 | 40 | 0.3% |
| thanos::sroute:3a78a6e9-ef19-43ae-832e-e4a3868eb32d | 39 | 0.3% |
| thanos::sroute:5dd1132a-b8a0-4b55-9df1-08937607bb65 | 37 | 0.3% |
| thanos::sroute:b743d024-a50a-40a4-8ffd-e3b420b7534e | 36 | 0.2% |
| thanos::sroute:ad01057e-be3e-42d5-8380-4fd6d174ec89 | 35 | 0.2% |
| thanos::sroute:faef8565-4919-4d38-b5a6-a81f9c1da35c | 34 | 0.2% |
| Other values (1487) | 14383 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 59148 | 7.8% |
| a | 47233 | 6.3% |
| : | 44361 | 5.9% |
| e | 42479 | 5.6% |
| 4 | 41899 | 5.6% |
| 9 | 31478 | 4.2% |
| 8 | 31234 | 4.1% |
| b | 30824 | 4.1% |
| t | 29574 | 3.9% |
| o | 29574 | 3.9% |
| Other values (15) | 366333 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 754137 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 59148 | 7.8% |
| a | 47233 | 6.3% |
| : | 44361 | 5.9% |
| e | 42479 | 5.6% |
| 4 | 41899 | 5.6% |
| 9 | 31478 | 4.2% |
| 8 | 31234 | 4.1% |
| b | 30824 | 4.1% |
| t | 29574 | 3.9% |
| o | 29574 | 3.9% |
| Other values (15) | 366333 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 754137 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 59148 | 7.8% |
| a | 47233 | 6.3% |
| : | 44361 | 5.9% |
| e | 42479 | 5.6% |
| 4 | 41899 | 5.6% |
| 9 | 31478 | 4.2% |
| 8 | 31234 | 4.1% |
| b | 30824 | 4.1% |
| t | 29574 | 3.9% |
| o | 29574 | 3.9% |
| Other values (15) | 366333 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 754137 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 59148 | 7.8% |
| a | 47233 | 6.3% |
| : | 44361 | 5.9% |
| e | 42479 | 5.6% |
| 4 | 41899 | 5.6% |
| 9 | 31478 | 4.2% |
| 8 | 31234 | 4.1% |
| b | 30824 | 4.1% |
| t | 29574 | 3.9% |
| o | 29574 | 3.9% |
| Other values (15) | 366333 |
route_type
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
| Carting | |
|---|---|
| FTL |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 5.4091432 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FTL |
|---|---|
| 2nd row | Carting |
| 3rd row | FTL |
| 4th row | Carting |
| 5th row | FTL |
Common Values
| Value | Count | Frequency (%) |
| Carting | 8906 | |
| FTL | 5881 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| carting | 8906 | |
| ftl | 5881 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 8906 | |
| a | 8906 | |
| r | 8906 | |
| t | 8906 | |
| i | 8906 | |
| n | 8906 | |
| g | 8906 | |
| F | 5881 | |
| T | 5881 | |
| L | 5881 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 79985 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 8906 | |
| a | 8906 | |
| r | 8906 | |
| t | 8906 | |
| i | 8906 | |
| n | 8906 | |
| g | 8906 | |
| F | 5881 | |
| T | 5881 | |
| L | 5881 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 79985 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 8906 | |
| a | 8906 | |
| r | 8906 | |
| t | 8906 | |
| i | 8906 | |
| n | 8906 | |
| g | 8906 | |
| F | 5881 | |
| T | 5881 | |
| L | 5881 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 79985 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 8906 | |
| a | 8906 | |
| r | 8906 | |
| t | 8906 | |
| i | 8906 | |
| n | 8906 | |
| g | 8906 | |
| F | 5881 | |
| T | 5881 | |
| L | 5881 |
start_scan_to_end_scan
Real number (ℝ)
High correlation 
| Distinct | 2203 |
|---|---|
| Distinct (%) | 14.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 529.42903 |
| Minimum | 23 |
|---|---|
| Maximum | 7898 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 115.7 KiB |
Quantile statistics
| Minimum | 23 |
|---|---|
| 5-th percentile | 71 |
| Q1 | 149 |
| median | 279 |
| Q3 | 632 |
| 95-th percentile | 1892.1 |
| Maximum | 7898 |
| Range | 7875 |
| Interquartile range (IQR) | 483 |
Descriptive statistics
| Standard deviation | 658.25494 |
|---|---|
| Coefficient of variation (CV) | 1.2433299 |
| Kurtosis | 11.100934 |
| Mean | 529.42903 |
| Median Absolute Deviation (MAD) | 164 |
| Skewness | 2.8953365 |
| Sum | 7828667 |
| Variance | 433299.56 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 115 | 51 | 0.3% |
| 148 | 51 | 0.3% |
| 87 | 50 | 0.3% |
| 128 | 49 | 0.3% |
| 113 | 49 | 0.3% |
| 170 | 48 | 0.3% |
| 105 | 48 | 0.3% |
| 99 | 48 | 0.3% |
| 150 | 47 | 0.3% |
| 135 | 47 | 0.3% |
| Other values (2193) | 14299 |
| Value | Count | Frequency (%) |
| 23 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 27 | 3 | < 0.1% |
| 28 | 4 | < 0.1% |
| 29 | 2 | < 0.1% |
| 30 | 2 | < 0.1% |
| 31 | 8 | |
| 32 | 4 | < 0.1% |
| 33 | 8 | |
| 34 | 11 |
| Value | Count | Frequency (%) |
| 7898 | 1 | |
| 7458 | 1 | |
| 6495 | 1 | |
| 5864 | 1 | |
| 5807 | 1 | |
| 5688 | 1 | |
| 5686 | 1 | |
| 4846 | 1 | |
| 4699 | 1 | |
| 4616 | 1 |
actual_distance_to_destination
Real number (ℝ)
High correlation 
| Distinct | 14771 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 164.0902 |
| Minimum | 9.0024614 |
|---|---|
| Maximum | 2186.5318 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 115.7 KiB |
Quantile statistics
| Minimum | 9.0024614 |
|---|---|
| 5-th percentile | 11.097212 |
| Q1 | 22.777099 |
| median | 48.287894 |
| Q3 | 163.59126 |
| 95-th percentile | 829.17455 |
| Maximum | 2186.5318 |
| Range | 2177.5293 |
| Interquartile range (IQR) | 140.81416 |
Descriptive statistics
| Standard deviation | 305.50298 |
|---|---|
| Coefficient of variation (CV) | 1.8617991 |
| Kurtosis | 13.699595 |
| Mean | 164.0902 |
| Median Absolute Deviation (MAD) | 33.249556 |
| Skewness | 3.5629313 |
| Sum | 2426401.7 |
| Variance | 93332.072 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.18625572 | 2 | < 0.1% |
| 32.17709214 | 2 | < 0.1% |
| 17.48464859 | 2 | < 0.1% |
| 26.58161002 | 2 | < 0.1% |
| 25.1427725 | 2 | < 0.1% |
| 195.5579057 | 2 | < 0.1% |
| 23.03404243 | 2 | < 0.1% |
| 27.95996726 | 2 | < 0.1% |
| 18.03636646 | 2 | < 0.1% |
| 25.24434706 | 2 | < 0.1% |
| Other values (14761) | 14767 |
| Value | Count | Frequency (%) |
| 9.002461442 | 1 | |
| 9.003577518 | 1 | |
| 9.004037718 | 1 | |
| 9.006254595 | 1 | |
| 9.006827116 | 1 | |
| 9.007520875 | 1 | |
| 9.007658103 | 1 | |
| 9.01049775 | 1 | |
| 9.016697542 | 1 | |
| 9.018870024 | 1 |
| Value | Count | Frequency (%) |
| 2186.531787 | 1 | |
| 2186.098218 | 1 | |
| 2185.663823 | 1 | |
| 2185.480257 | 1 | |
| 2185.379628 | 1 | |
| 2185.371321 | 1 | |
| 2184.055501 | 1 | |
| 2183.749474 | 1 | |
| 2183.481081 | 1 | |
| 2183.315555 | 1 |
actual_time
Real number (ℝ)
High correlation 
| Distinct | 1850 |
|---|---|
| Distinct (%) | 12.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 356.30601 |
| Minimum | 9 |
|---|---|
| Maximum | 6265 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 115.7 KiB |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 32 |
| Q1 | 67 |
| median | 148 |
| Q3 | 367 |
| 95-th percentile | 1472.4 |
| Maximum | 6265 |
| Range | 6256 |
| Interquartile range (IQR) | 300 |
Descriptive statistics
| Standard deviation | 561.51794 |
|---|---|
| Coefficient of variation (CV) | 1.5759429 |
| Kurtosis | 13.836985 |
| Mean | 356.30601 |
| Median Absolute Deviation (MAD) | 99 |
| Skewness | 3.3751783 |
| Sum | 5268697 |
| Variance | 315302.39 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 60 | 134 | 0.9% |
| 50 | 130 | 0.9% |
| 42 | 121 | 0.8% |
| 48 | 115 | 0.8% |
| 38 | 111 | 0.8% |
| 54 | 107 | 0.7% |
| 72 | 103 | 0.7% |
| 58 | 101 | 0.7% |
| 66 | 99 | 0.7% |
| 36 | 94 | 0.6% |
| Other values (1840) | 13672 |
| Value | Count | Frequency (%) |
| 9 | 2 | < 0.1% |
| 10 | 4 | < 0.1% |
| 11 | 6 | < 0.1% |
| 12 | 8 | 0.1% |
| 13 | 16 | |
| 14 | 28 | |
| 15 | 14 | |
| 16 | 19 | |
| 17 | 18 | |
| 18 | 31 |
| Value | Count | Frequency (%) |
| 6265 | 1 | |
| 5804 | 1 | |
| 5465 | 1 | |
| 5067 | 1 | |
| 5064 | 1 | |
| 4687 | 1 | |
| 4532 | 1 | |
| 4267 | 1 | |
| 4263 | 1 | |
| 4154 | 1 |
osrm_time
Real number (ℝ)
High correlation 
| Distinct | 814 |
|---|---|
| Distinct (%) | 5.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 160.99094 |
| Minimum | 6 |
|---|---|
| Maximum | 2032 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 115.7 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 14 |
| Q1 | 29 |
| median | 60 |
| Q3 | 168 |
| 95-th percentile | 710 |
| Maximum | 2032 |
| Range | 2026 |
| Interquartile range (IQR) | 139 |
Descriptive statistics
| Standard deviation | 271.45949 |
|---|---|
| Coefficient of variation (CV) | 1.6861787 |
| Kurtosis | 13.248508 |
| Mean | 160.99094 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 3.455256 |
| Sum | 2380573 |
| Variance | 73690.257 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 34 | 268 | 1.8% |
| 20 | 262 | 1.8% |
| 29 | 261 | 1.8% |
| 23 | 240 | 1.6% |
| 32 | 238 | 1.6% |
| 22 | 233 | 1.6% |
| 17 | 223 | 1.5% |
| 33 | 215 | 1.5% |
| 16 | 206 | 1.4% |
| 21 | 203 | 1.4% |
| Other values (804) | 12438 |
| Value | Count | Frequency (%) |
| 6 | 1 | < 0.1% |
| 7 | 19 | 0.1% |
| 8 | 35 | 0.2% |
| 9 | 39 | 0.3% |
| 10 | 88 | |
| 11 | 118 | |
| 12 | 167 | |
| 13 | 136 | |
| 14 | 147 | |
| 15 | 199 |
| Value | Count | Frequency (%) |
| 2032 | 2 | < 0.1% |
| 2031 | 2 | < 0.1% |
| 2030 | 1 | < 0.1% |
| 1917 | 1 | < 0.1% |
| 1873 | 3 | |
| 1872 | 1 | < 0.1% |
| 1871 | 5 | |
| 1870 | 4 | |
| 1869 | 2 | < 0.1% |
| 1867 | 1 | < 0.1% |
osrm_distance
Real number (ℝ)
High correlation 
| Distinct | 14702 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 203.88741 |
| Minimum | 9.0729 |
|---|---|
| Maximum | 2840.081 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 115.7 KiB |
Quantile statistics
| Minimum | 9.0729 |
|---|---|
| 5-th percentile | 14.96663 |
| Q1 | 30.7569 |
| median | 65.3028 |
| Q3 | 206.6442 |
| 95-th percentile | 969.58967 |
| Maximum | 2840.081 |
| Range | 2831.0081 |
| Interquartile range (IQR) | 175.8873 |
Descriptive statistics
| Standard deviation | 370.56556 |
|---|---|
| Coefficient of variation (CV) | 1.817501 |
| Kurtosis | 13.823126 |
| Mean | 203.88741 |
| Median Absolute Deviation (MAD) | 45.2799 |
| Skewness | 3.5536187 |
| Sum | 3014883.2 |
| Variance | 137318.84 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 35.7346 | 2 | < 0.1% |
| 13.4217 | 2 | < 0.1% |
| 17.8604 | 2 | < 0.1% |
| 34.7344 | 2 | < 0.1% |
| 20.0424 | 2 | < 0.1% |
| 16.346 | 2 | < 0.1% |
| 27.7116 | 2 | < 0.1% |
| 37.0811 | 2 | < 0.1% |
| 78.7434 | 2 | < 0.1% |
| 13.0535 | 2 | < 0.1% |
| Other values (14692) | 14767 |
| Value | Count | Frequency (%) |
| 9.0729 | 1 | |
| 9.1364 | 1 | |
| 9.2903 | 1 | |
| 9.3227 | 1 | |
| 9.3301 | 1 | |
| 9.3353 | 1 | |
| 9.3908 | 1 | |
| 9.3999 | 1 | |
| 9.4185 | 1 | |
| 9.6473 | 1 |
| Value | Count | Frequency (%) |
| 2840.081 | 1 | |
| 2839.6603 | 1 | |
| 2839.3582 | 1 | |
| 2838.8811 | 1 | |
| 2837.7608 | 1 | |
| 2670.2059 | 1 | |
| 2555.7542 | 1 | |
| 2555.6566 | 1 | |
| 2555.5269 | 1 | |
| 2555.4428 | 1 |
segment_actual_time_sum
Real number (ℝ)
High correlation 
| Distinct | 1885 |
|---|---|
| Distinct (%) | 12.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 353.05917 |
| Minimum | 9 |
|---|---|
| Maximum | 6230 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 115.7 KiB |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 32 |
| Q1 | 66 |
| median | 147 |
| Q3 | 364 |
| 95-th percentile | 1458.2 |
| Maximum | 6230 |
| Range | 6221 |
| Interquartile range (IQR) | 298 |
Descriptive statistics
| Standard deviation | 556.36591 |
|---|---|
| Coefficient of variation (CV) | 1.5758432 |
| Kurtosis | 13.833819 |
| Mean | 353.05917 |
| Median Absolute Deviation (MAD) | 99 |
| Skewness | 3.3720425 |
| Sum | 5220686 |
| Variance | 309543.03 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 47 | 121 | 0.8% |
| 41 | 112 | 0.8% |
| 60 | 107 | 0.7% |
| 55 | 100 | 0.7% |
| 35 | 100 | 0.7% |
| 53 | 98 | 0.7% |
| 49 | 98 | 0.7% |
| 39 | 98 | 0.7% |
| 45 | 95 | 0.6% |
| 74 | 94 | 0.6% |
| Other values (1875) | 13764 |
| Value | Count | Frequency (%) |
| 9 | 2 | < 0.1% |
| 10 | 4 | < 0.1% |
| 11 | 6 | < 0.1% |
| 12 | 9 | 0.1% |
| 13 | 20 | |
| 14 | 27 | |
| 15 | 14 | |
| 16 | 16 | |
| 17 | 27 | |
| 18 | 28 |
| Value | Count | Frequency (%) |
| 6230 | 1 | |
| 5768 | 1 | |
| 5427 | 1 | |
| 5032 | 1 | |
| 5028 | 1 | |
| 4642 | 1 | |
| 4504 | 1 | |
| 4222 | 1 | |
| 4214 | 1 | |
| 4129 | 1 |
segment_osrm_time_sum
Real number (ℝ)
High correlation 
| Distinct | 1240 |
|---|---|
| Distinct (%) | 8.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 180.5116 |
| Minimum | 6 |
|---|---|
| Maximum | 2564 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 115.7 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 30 |
| median | 65 |
| Q3 | 184 |
| 95-th percentile | 833.7 |
| Maximum | 2564 |
| Range | 2558 |
| Interquartile range (IQR) | 154 |
Descriptive statistics
| Standard deviation | 314.67928 |
|---|---|
| Coefficient of variation (CV) | 1.7432635 |
| Kurtosis | 14.570176 |
| Mean | 180.5116 |
| Median Absolute Deviation (MAD) | 45 |
| Skewness | 3.6029152 |
| Sum | 2669225 |
| Variance | 99023.049 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17 | 221 | 1.5% |
| 20 | 213 | 1.4% |
| 19 | 210 | 1.4% |
| 18 | 209 | 1.4% |
| 22 | 208 | 1.4% |
| 23 | 204 | 1.4% |
| 21 | 188 | 1.3% |
| 28 | 184 | 1.2% |
| 35 | 180 | 1.2% |
| 30 | 180 | 1.2% |
| Other values (1230) | 12790 |
| Value | Count | Frequency (%) |
| 6 | 1 | < 0.1% |
| 7 | 22 | 0.1% |
| 8 | 25 | 0.2% |
| 9 | 61 | 0.4% |
| 10 | 79 | |
| 11 | 115 | |
| 12 | 151 | |
| 13 | 131 | |
| 14 | 125 | |
| 15 | 175 |
| Value | Count | Frequency (%) |
| 2564 | 1 | |
| 2530 | 1 | |
| 2510 | 1 | |
| 2494 | 1 | |
| 2422 | 1 | |
| 2350 | 1 | |
| 2346 | 1 | |
| 2326 | 1 | |
| 2320 | 1 | |
| 2313 | 1 |
segment_osrm_distance_sum
Real number (ℝ)
High correlation 
| Distinct | 14718 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 222.70547 |
| Minimum | 9.0729 |
|---|---|
| Maximum | 3523.6324 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 115.7 KiB |
Quantile statistics
| Minimum | 9.0729 |
|---|---|
| 5-th percentile | 15.36056 |
| Q1 | 32.57885 |
| median | 69.7842 |
| Q3 | 216.5606 |
| 95-th percentile | 1106.2946 |
| Maximum | 3523.6324 |
| Range | 3514.5595 |
| Interquartile range (IQR) | 183.98175 |
Descriptive statistics
| Standard deviation | 416.84628 |
|---|---|
| Coefficient of variation (CV) | 1.871738 |
| Kurtosis | 15.372075 |
| Mean | 222.70547 |
| Median Absolute Deviation (MAD) | 49.1334 |
| Skewness | 3.7140165 |
| Sum | 3293145.7 |
| Variance | 173760.82 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14.1177 | 2 | < 0.1% |
| 51.5355 | 2 | < 0.1% |
| 45.6356 | 2 | < 0.1% |
| 32.9795 | 2 | < 0.1% |
| 27.5998 | 2 | < 0.1% |
| 14.95 | 2 | < 0.1% |
| 16.1861 | 2 | < 0.1% |
| 38.1914 | 2 | < 0.1% |
| 50.6246 | 2 | < 0.1% |
| 19.5174 | 2 | < 0.1% |
| Other values (14708) | 14767 |
| Value | Count | Frequency (%) |
| 9.0729 | 1 | |
| 9.1364 | 1 | |
| 9.2903 | 1 | |
| 9.3227 | 1 | |
| 9.3301 | 1 | |
| 9.3353 | 1 | |
| 9.3908 | 1 | |
| 9.3999 | 1 | |
| 9.4185 | 1 | |
| 9.6473 | 1 |
| Value | Count | Frequency (%) |
| 3523.6324 | 1 | |
| 3489.9866 | 1 | |
| 3456.0357 | 1 | |
| 3418.1829 | 1 | |
| 3367.3834 | 1 | |
| 3251.1052 | 1 | |
| 3250.869 | 1 | |
| 3238.744 | 1 | |
| 3213.4054 | 1 | |
| 3204.0404 | 1 |
od_time_diff_hour
Real number (ℝ)
High correlation  Unique 
| Distinct | 14787 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 546.12445 |
| Minimum | 23.461468 |
|---|---|
| Maximum | 7898.552 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 115.7 KiB |
Quantile statistics
| Minimum | 23.461468 |
|---|---|
| 5-th percentile | 71.203377 |
| Q1 | 150.93155 |
| median | 287.42123 |
| Q3 | 670.64299 |
| 95-th percentile | 1939.7819 |
| Maximum | 7898.552 |
| Range | 7875.0905 |
| Interquartile range (IQR) | 519.71144 |
Descriptive statistics
| Standard deviation | 668.16505 |
|---|---|
| Coefficient of variation (CV) | 1.2234666 |
| Kurtosis | 10.25297 |
| Mean | 546.12445 |
| Median Absolute Deviation (MAD) | 172.71894 |
| Skewness | 2.7775483 |
| Sum | 8075542.2 |
| Variance | 446444.53 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 354.4075714 | 1 | < 0.1% |
| 2260.1098 | 1 | < 0.1% |
| 181.6118738 | 1 | < 0.1% |
| 148.7947178 | 1 | < 0.1% |
| 158.3375369 | 1 | < 0.1% |
| 254.721952 | 1 | < 0.1% |
| 257.7081947 | 1 | < 0.1% |
| 113.8599436 | 1 | < 0.1% |
| 2182.120429 | 1 | < 0.1% |
| 1019.486964 | 1 | < 0.1% |
| Other values (14777) | 14777 |
| Value | Count | Frequency (%) |
| 23.46146848 | 1 | |
| 26.49916442 | 1 | |
| 26.5808515 | 1 | |
| 27.63686067 | 1 | |
| 27.73261922 | 1 | |
| 27.79866977 | 1 | |
| 28.17911532 | 1 | |
| 28.42774028 | 1 | |
| 28.92702358 | 1 | |
| 28.98354038 | 1 |
| Value | Count | Frequency (%) |
| 7898.551955 | 1 | |
| 7458.939519 | 1 | |
| 6496.022231 | 1 | |
| 5864.79313 | 1 | |
| 5807.995124 | 1 | |
| 5689.14172 | 1 | |
| 5686.743719 | 1 | |
| 4847.14009 | 1 | |
| 4699.692937 | 1 | |
| 4616.736291 | 1 |
dest_state
Categorical
High correlation 
| Distinct | 32 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
| maharashtra | |
|---|---|
| karnataka | |
| haryana | |
| tamil nadu | |
| uttar pradesh | |
| Other values (27) |
Length
| Max length | 22 |
|---|---|
| Median length | 16 |
| Mean length | 9.273754 |
| Min length | 3 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | uttar pradesh |
|---|---|
| 2nd row | karnataka |
| 3rd row | haryana |
| 4th row | maharashtra |
| 5th row | karnataka |
Common Values
| Value | Count | Frequency (%) |
| maharashtra | 2549 | |
| karnataka | 2303 | |
| haryana | 1567 | |
| tamil nadu | 1043 | 7.1% |
| uttar pradesh | 866 | 5.9% |
| gujarat | 739 | 5.0% |
| telangana | 730 | 4.9% |
| west bengal | 665 | 4.5% |
| delhi | 627 | 4.2% |
| rajasthan | 556 | 3.8% |
| Other values (22) | 3142 |
Length
| Value | Count | Frequency (%) |
| maharashtra | 2549 | |
| karnataka | 2303 | |
| pradesh | 1826 | 9.9% |
| haryana | 1567 | 8.5% |
| tamil | 1043 | 5.7% |
| nadu | 1043 | 5.7% |
| uttar | 866 | 4.7% |
| gujarat | 739 | 4.0% |
| telangana | 730 | 4.0% |
| west | 665 | 3.6% |
| Other values (31) | 5093 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 40243 | |
| r | 14837 | 10.8% |
| h | 12011 | 8.8% |
| t | 10670 | 7.8% |
| n | 9084 | 6.6% |
| s | 6474 | 4.7% |
| k | 5242 | 3.8% |
| e | 4834 | 3.5% |
| d | 4826 | 3.5% |
| m | 4388 | 3.2% |
| Other values (15) | 24522 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 137131 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 40243 | |
| r | 14837 | 10.8% |
| h | 12011 | 8.8% |
| t | 10670 | 7.8% |
| n | 9084 | 6.6% |
| s | 6474 | 4.7% |
| k | 5242 | 3.8% |
| e | 4834 | 3.5% |
| d | 4826 | 3.5% |
| m | 4388 | 3.2% |
| Other values (15) | 24522 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 137131 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 40243 | |
| r | 14837 | 10.8% |
| h | 12011 | 8.8% |
| t | 10670 | 7.8% |
| n | 9084 | 6.6% |
| s | 6474 | 4.7% |
| k | 5242 | 3.8% |
| e | 4834 | 3.5% |
| d | 4826 | 3.5% |
| m | 4388 | 3.2% |
| Other values (15) | 24522 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 137131 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 40243 | |
| r | 14837 | 10.8% |
| h | 12011 | 8.8% |
| t | 10670 | 7.8% |
| n | 9084 | 6.6% |
| s | 6474 | 4.7% |
| k | 5242 | 3.8% |
| e | 4834 | 3.5% |
| d | 4826 | 3.5% |
| m | 4388 | 3.2% |
| Other values (15) | 24522 |
dest_city
Text
| Distinct | 919 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 17 |
| Mean length | 7.4887401 |
| Min length | 2 |
Unique
| Unique | 207 ? |
|---|---|
| Unique (%) | 1.4% |
Sample
| 1st row | kanpur |
|---|---|
| 2nd row | doddablpur |
| 3rd row | gurgaon |
| 4th row | mumbai |
| 5th row | hospet |
| Value | Count | Frequency (%) |
| mumbai | 1159 | 7.4% |
| bengaluru | 1122 | 7.2% |
| gurgaon | 842 | 5.4% |
| delhi | 510 | 3.3% |
| bangalore | 503 | 3.2% |
| hyderabad | 426 | 2.7% |
| chennai | 413 | 2.7% |
| bhiwandi | 396 | 2.5% |
| pune | 296 | 1.9% |
| sonipat | 278 | 1.8% |
| Other values (906) | 9631 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 20018 | |
| r | 8966 | 8.1% |
| n | 8464 | 7.6% |
| u | 8283 | 7.5% |
| i | 6929 | 6.3% |
| h | 6093 | 5.5% |
| b | 5940 | 5.4% |
| g | 5547 | 5.0% |
| d | 5345 | 4.8% |
| l | 4981 | 4.5% |
| Other values (17) | 30170 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 110736 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 20018 | |
| r | 8966 | 8.1% |
| n | 8464 | 7.6% |
| u | 8283 | 7.5% |
| i | 6929 | 6.3% |
| h | 6093 | 5.5% |
| b | 5940 | 5.4% |
| g | 5547 | 5.0% |
| d | 5345 | 4.8% |
| l | 4981 | 4.5% |
| Other values (17) | 30170 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 110736 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 20018 | |
| r | 8966 | 8.1% |
| n | 8464 | 7.6% |
| u | 8283 | 7.5% |
| i | 6929 | 6.3% |
| h | 6093 | 5.5% |
| b | 5940 | 5.4% |
| g | 5547 | 5.0% |
| d | 5345 | 4.8% |
| l | 4981 | 4.5% |
| Other values (17) | 30170 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 110736 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 20018 | |
| r | 8966 | 8.1% |
| n | 8464 | 7.6% |
| u | 8283 | 7.5% |
| i | 6929 | 6.3% |
| h | 6093 | 5.5% |
| b | 5940 | 5.4% |
| g | 5547 | 5.0% |
| d | 5345 | 4.8% |
| l | 4981 | 4.5% |
| Other values (17) | 30170 |
dest_place
Text
| Distinct | 914 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
Length
| Max length | 16 |
|---|---|
| Median length | 8 |
| Mean length | 7.4470143 |
| Min length | 1 |
Unique
| Unique | 191 ? |
|---|---|
| Unique (%) | 1.3% |
Sample
| 1st row | central |
|---|---|
| 2nd row | chikadpp |
| 3rd row | bilaspur |
| 4th row | mirard |
| 5th row | hospet |
| Value | Count | Frequency (%) |
| bilaspur | 829 | 5.6% |
| central | 767 | 5.1% |
| nelmngla | 503 | 3.4% |
| mankoli | 396 | 2.7% |
| bomsndra | 358 | 2.4% |
| shamshbd | 283 | 1.9% |
| kundli | 276 | 1.9% |
| kgairprt | 272 | 1.8% |
| mumbai | 237 | 1.6% |
| tathawde | 231 | 1.5% |
| Other values (907) | 10754 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 15478 | |
| r | 10739 | 9.8% |
| n | 8757 | 8.0% |
| l | 6465 | 5.9% |
| d | 5956 | 5.4% |
| i | 5955 | 5.4% |
| p | 5703 | 5.2% |
| h | 5497 | 5.0% |
| m | 5123 | 4.7% |
| t | 4755 | 4.3% |
| Other values (28) | 35691 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 110119 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 15478 | |
| r | 10739 | 9.8% |
| n | 8757 | 8.0% |
| l | 6465 | 5.9% |
| d | 5956 | 5.4% |
| i | 5955 | 5.4% |
| p | 5703 | 5.2% |
| h | 5497 | 5.0% |
| m | 5123 | 4.7% |
| t | 4755 | 4.3% |
| Other values (28) | 35691 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 110119 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 15478 | |
| r | 10739 | 9.8% |
| n | 8757 | 8.0% |
| l | 6465 | 5.9% |
| d | 5956 | 5.4% |
| i | 5955 | 5.4% |
| p | 5703 | 5.2% |
| h | 5497 | 5.0% |
| m | 5123 | 4.7% |
| t | 4755 | 4.3% |
| Other values (28) | 35691 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 110119 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 15478 | |
| r | 10739 | 9.8% |
| n | 8757 | 8.0% |
| l | 6465 | 5.9% |
| d | 5956 | 5.4% |
| i | 5955 | 5.4% |
| p | 5703 | 5.2% |
| h | 5497 | 5.0% |
| m | 5123 | 4.7% |
| t | 4755 | 4.3% |
| Other values (28) | 35691 |
dest_code
Text
| Distinct | 57 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 2 |
| Mean length | 2.6654494 |
| Min length | 2 |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 6 |
|---|---|
| 2nd row | d |
| 3rd row | hb |
| 4th row | ip |
| 5th row | none |
| Value | Count | Frequency (%) |
| d | 3709 | |
| hb | 2087 | |
| h | 1651 | |
| dc | 1246 | 8.4% |
| i | 976 | 6.6% |
| dpc | 877 | 5.9% |
| none | 801 | 5.4% |
| l | 615 | 4.2% |
| ip | 565 | 3.8% |
| hub | 361 | 2.4% |
| Other values (49) | 1915 |
Most occurring characters
| Value | Count | Frequency (%) |
| 14002 | ||
| d | 5856 | |
| h | 4144 | 10.5% |
| c | 2550 | 6.5% |
| b | 2461 | 6.2% |
| p | 2075 | 5.3% |
| n | 1691 | 4.3% |
| i | 1646 | 4.2% |
| e | 979 | 2.5% |
| o | 853 | 2.2% |
| Other values (23) | 3157 | 8.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 39414 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 14002 | ||
| d | 5856 | |
| h | 4144 | 10.5% |
| c | 2550 | 6.5% |
| b | 2461 | 6.2% |
| p | 2075 | 5.3% |
| n | 1691 | 4.3% |
| i | 1646 | 4.2% |
| e | 979 | 2.5% |
| o | 853 | 2.2% |
| Other values (23) | 3157 | 8.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 39414 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 14002 | ||
| d | 5856 | |
| h | 4144 | 10.5% |
| c | 2550 | 6.5% |
| b | 2461 | 6.2% |
| p | 2075 | 5.3% |
| n | 1691 | 4.3% |
| i | 1646 | 4.2% |
| e | 979 | 2.5% |
| o | 853 | 2.2% |
| Other values (23) | 3157 | 8.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 39414 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 14002 | ||
| d | 5856 | |
| h | 4144 | 10.5% |
| c | 2550 | 6.5% |
| b | 2461 | 6.2% |
| p | 2075 | 5.3% |
| n | 1691 | 4.3% |
| i | 1646 | 4.2% |
| e | 979 | 2.5% |
| o | 853 | 2.2% |
| Other values (23) | 3157 | 8.0% |
source_state
Categorical
High correlation 
| Distinct | 29 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
| maharashtra | |
|---|---|
| karnataka | |
| haryana | |
| tamil nadu | |
| delhi | |
| Other values (24) |
Length
| Max length | 22 |
|---|---|
| Median length | 16 |
| Mean length | 9.0933252 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | madhya pradesh |
|---|---|
| 2nd row | karnataka |
| 3rd row | karnataka |
| 4th row | maharashtra |
| 5th row | karnataka |
Common Values
| Value | Count | Frequency (%) |
| maharashtra | 2682 | |
| karnataka | 2229 | |
| haryana | 1669 | |
| tamil nadu | 1085 | 7.3% |
| delhi | 790 | 5.3% |
| telangana | 779 | 5.3% |
| gujarat | 746 | 5.0% |
| uttar pradesh | 719 | 4.9% |
| west bengal | 677 | 4.6% |
| punjab | 630 | 4.3% |
| Other values (19) | 2781 |
Length
| Value | Count | Frequency (%) |
| maharashtra | 2682 | |
| karnataka | 2229 | |
| haryana | 1669 | 9.2% |
| pradesh | 1497 | 8.3% |
| tamil | 1085 | 6.0% |
| nadu | 1085 | 6.0% |
| delhi | 790 | 4.4% |
| telangana | 779 | 4.3% |
| gujarat | 746 | 4.1% |
| uttar | 719 | 4.0% |
| Other values (27) | 4844 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 39853 | |
| r | 14322 | 10.7% |
| h | 11686 | 8.7% |
| t | 10443 | 7.8% |
| n | 9126 | 6.8% |
| s | 6169 | 4.6% |
| k | 5038 | 3.7% |
| e | 4736 | 3.5% |
| d | 4496 | 3.3% |
| m | 4466 | 3.3% |
| Other values (15) | 24128 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 134463 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 39853 | |
| r | 14322 | 10.7% |
| h | 11686 | 8.7% |
| t | 10443 | 7.8% |
| n | 9126 | 6.8% |
| s | 6169 | 4.6% |
| k | 5038 | 3.7% |
| e | 4736 | 3.5% |
| d | 4496 | 3.3% |
| m | 4466 | 3.3% |
| Other values (15) | 24128 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 134463 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 39853 | |
| r | 14322 | 10.7% |
| h | 11686 | 8.7% |
| t | 10443 | 7.8% |
| n | 9126 | 6.8% |
| s | 6169 | 4.6% |
| k | 5038 | 3.7% |
| e | 4736 | 3.5% |
| d | 4496 | 3.3% |
| m | 4466 | 3.3% |
| Other values (15) | 24128 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 134463 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 39853 | |
| r | 14322 | 10.7% |
| h | 11686 | 8.7% |
| t | 10443 | 7.8% |
| n | 9126 | 6.8% |
| s | 6169 | 4.6% |
| k | 5038 | 3.7% |
| e | 4736 | 3.5% |
| d | 4496 | 3.3% |
| m | 4466 | 3.3% |
| Other values (15) | 24128 |
source_city
Text
| Distinct | 679 |
|---|---|
| Distinct (%) | 4.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 17 |
| Mean length | 7.4769054 |
| Min length | 3 |
Unique
| Unique | 235 ? |
|---|---|
| Unique (%) | 1.6% |
Sample
| 1st row | bhopal |
|---|---|
| 2nd row | tumkur |
| 3rd row | bangalore |
| 4th row | mumbai hub |
| 5th row | bellary |
| Value | Count | Frequency (%) |
| bengaluru | 1015 | 6.6% |
| gurgaon | 1013 | 6.6% |
| mumbai | 893 | 5.8% |
| bhiwandi | 811 | 5.3% |
| bangalore | 755 | 4.9% |
| delhi | 617 | 4.0% |
| hyderabad | 562 | 3.6% |
| pune | 445 | 2.9% |
| chandigarh | 418 | 2.7% |
| kolkata | 339 | 2.2% |
| Other values (668) | 8576 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 19689 | |
| r | 8818 | 8.0% |
| u | 8127 | 7.4% |
| n | 8096 | 7.3% |
| i | 7138 | 6.5% |
| h | 6379 | 5.8% |
| b | 6317 | 5.7% |
| d | 5923 | 5.4% |
| g | 5685 | 5.1% |
| e | 5447 | 4.9% |
| Other values (17) | 28942 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 110561 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 19689 | |
| r | 8818 | 8.0% |
| u | 8127 | 7.4% |
| n | 8096 | 7.3% |
| i | 7138 | 6.5% |
| h | 6379 | 5.8% |
| b | 6317 | 5.7% |
| d | 5923 | 5.4% |
| g | 5685 | 5.1% |
| e | 5447 | 4.9% |
| Other values (17) | 28942 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 110561 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 19689 | |
| r | 8818 | 8.0% |
| u | 8127 | 7.4% |
| n | 8096 | 7.3% |
| i | 7138 | 6.5% |
| h | 6379 | 5.8% |
| b | 6317 | 5.7% |
| d | 5923 | 5.4% |
| g | 5685 | 5.1% |
| e | 5447 | 4.9% |
| Other values (17) | 28942 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 110561 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 19689 | |
| r | 8818 | 8.0% |
| u | 8127 | 7.4% |
| n | 8096 | 7.3% |
| i | 7138 | 6.5% |
| h | 6379 | 5.8% |
| b | 6317 | 5.7% |
| d | 5923 | 5.4% |
| g | 5685 | 5.1% |
| e | 5447 | 4.9% |
| Other values (17) | 28942 |
source_place
Text
| Distinct | 713 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
Length
| Max length | 16 |
|---|---|
| Median length | 14 |
| Mean length | 7.397579 |
| Min length | 3 |
Unique
| Unique | 227 ? |
|---|---|
| Unique (%) | 1.5% |
Sample
| 1st row | trnsport |
|---|---|
| 2nd row | veersagr |
| 3rd row | nelmngla |
| 4th row | mumbai |
| 5th row | bellary |
| Value | Count | Frequency (%) |
| central | 1039 | 7.0% |
| bilaspur | 959 | 6.5% |
| mankoli | 811 | 5.5% |
| nelmngla | 732 | 4.9% |
| bomsndra | 428 | 2.9% |
| mehmdpur | 370 | 2.5% |
| east | 363 | 2.4% |
| tathawde | 361 | 2.4% |
| kgairprt | 331 | 2.2% |
| mumbai | 325 | 2.2% |
| Other values (707) | 9141 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 15560 | |
| r | 9555 | 8.7% |
| n | 9070 | 8.3% |
| l | 7525 | 6.9% |
| i | 6422 | 5.9% |
| m | 5797 | 5.3% |
| e | 5756 | 5.3% |
| t | 5269 | 4.8% |
| h | 4979 | 4.6% |
| p | 4769 | 4.4% |
| Other values (28) | 34686 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 109388 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 15560 | |
| r | 9555 | 8.7% |
| n | 9070 | 8.3% |
| l | 7525 | 6.9% |
| i | 6422 | 5.9% |
| m | 5797 | 5.3% |
| e | 5756 | 5.3% |
| t | 5269 | 4.8% |
| h | 4979 | 4.6% |
| p | 4769 | 4.4% |
| Other values (28) | 34686 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 109388 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 15560 | |
| r | 9555 | 8.7% |
| n | 9070 | 8.3% |
| l | 7525 | 6.9% |
| i | 6422 | 5.9% |
| m | 5797 | 5.3% |
| e | 5756 | 5.3% |
| t | 5269 | 4.8% |
| h | 4979 | 4.6% |
| p | 4769 | 4.4% |
| Other values (28) | 34686 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 109388 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 15560 | |
| r | 9555 | 8.7% |
| n | 9070 | 8.3% |
| l | 7525 | 6.9% |
| i | 6422 | 5.9% |
| m | 5797 | 5.3% |
| e | 5756 | 5.3% |
| t | 5269 | 4.8% |
| h | 4979 | 4.6% |
| p | 4769 | 4.4% |
| Other values (28) | 34686 |
source_code
Text
| Distinct | 57 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 2 |
| Mean length | 2.6577399 |
| Min length | 2 |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | h |
|---|---|
| 2nd row | i |
| 3rd row | h |
| 4th row | none |
| 5th row | dc |
| Value | Count | Frequency (%) |
| hb | 3305 | |
| h | 2739 | |
| d | 1519 | |
| i | 1329 | |
| none | 640 | 4.3% |
| ip | 622 | 4.2% |
| 1 | 597 | 4.0% |
| dpc | 593 | 4.0% |
| dc | 501 | 3.4% |
| hub | 495 | 3.3% |
| Other values (51) | 2498 |
Most occurring characters
| Value | Count | Frequency (%) |
| 14198 | ||
| h | 6584 | |
| b | 3821 | 9.7% |
| d | 2693 | 6.9% |
| i | 2043 | 5.2% |
| c | 1916 | 4.9% |
| p | 1897 | 4.8% |
| n | 1336 | 3.4% |
| o | 751 | 1.9% |
| 1 | 694 | 1.8% |
| Other values (24) | 3367 | 8.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 39300 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 14198 | ||
| h | 6584 | |
| b | 3821 | 9.7% |
| d | 2693 | 6.9% |
| i | 2043 | 5.2% |
| c | 1916 | 4.9% |
| p | 1897 | 4.8% |
| n | 1336 | 3.4% |
| o | 751 | 1.9% |
| 1 | 694 | 1.8% |
| Other values (24) | 3367 | 8.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 39300 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 14198 | ||
| h | 6584 | |
| b | 3821 | 9.7% |
| d | 2693 | 6.9% |
| i | 2043 | 5.2% |
| c | 1916 | 4.9% |
| p | 1897 | 4.8% |
| n | 1336 | 3.4% |
| o | 751 | 1.9% |
| 1 | 694 | 1.8% |
| Other values (24) | 3367 | 8.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 39300 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 14198 | ||
| h | 6584 | |
| b | 3821 | 9.7% |
| d | 2693 | 6.9% |
| i | 2043 | 5.2% |
| c | 1916 | 4.9% |
| p | 1897 | 4.8% |
| n | 1336 | 3.4% |
| o | 751 | 1.9% |
| 1 | 694 | 1.8% |
| Other values (24) | 3367 | 8.6% |
trip_month
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
| 9 | |
|---|---|
| 10 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.1201055 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9 |
|---|---|
| 2nd row | 9 |
| 3rd row | 9 |
| 4th row | 9 |
| 5th row | 9 |
Common Values
| Value | Count | Frequency (%) |
| 9 | 13011 | |
| 10 | 1776 | 12.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 9 | 13011 | |
| 10 | 1776 | 12.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 13011 | |
| 1 | 1776 | 10.7% |
| 0 | 1776 | 10.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 16563 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 9 | 13011 | |
| 1 | 1776 | 10.7% |
| 0 | 1776 | 10.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 16563 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 9 | 13011 | |
| 1 | 1776 | 10.7% |
| 0 | 1776 | 10.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 16563 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 9 | 13011 | |
| 1 | 1776 | 10.7% |
| 0 | 1776 | 10.7% |
trip_hour
Real number (ℝ)
Zeros 
| Distinct | 24 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.456212 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 991 |
| Zeros (%) | 6.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 115.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 4 |
| median | 14 |
| Q3 | 20 |
| 95-th percentile | 23 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 7.9873869 |
|---|---|
| Coefficient of variation (CV) | 0.64123726 |
| Kurtosis | -1.4960835 |
| Mean | 12.456212 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | -0.20609177 |
| Sum | 184190 |
| Variance | 63.79835 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22 | 1123 | 7.6% |
| 23 | 1107 | 7.5% |
| 20 | 1080 | 7.3% |
| 0 | 991 | 6.7% |
| 21 | 872 | 5.9% |
| 19 | 837 | 5.7% |
| 1 | 748 | 5.1% |
| 2 | 702 | 4.7% |
| 18 | 696 | 4.7% |
| 3 | 651 | 4.4% |
| Other values (14) | 5980 |
| Value | Count | Frequency (%) |
| 0 | 991 | |
| 1 | 748 | |
| 2 | 702 | |
| 3 | 651 | |
| 4 | 635 | |
| 5 | 505 | |
| 6 | 610 | |
| 7 | 472 | |
| 8 | 345 | 2.3% |
| 9 | 317 | 2.1% |
| Value | Count | Frequency (%) |
| 23 | 1107 | |
| 22 | 1123 | |
| 21 | 872 | |
| 20 | 1080 | |
| 19 | 837 | |
| 18 | 696 | |
| 17 | 595 | |
| 16 | 526 | |
| 15 | 469 | |
| 14 | 379 | 2.6% |
trip_day
Real number (ℝ)
High correlation 
| Distinct | 22 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.375127 |
| Minimum | 1 |
|---|---|
| Maximum | 30 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 115.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 14 |
| median | 19 |
| Q3 | 25 |
| 95-th percentile | 29 |
| Maximum | 30 |
| Range | 29 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 7.8821985 |
|---|---|
| Coefficient of variation (CV) | 0.42896022 |
| Kurtosis | -0.1620419 |
| Mean | 18.375127 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -0.69524137 |
| Sum | 271713 |
| Variance | 62.129053 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18 | 791 | 5.3% |
| 15 | 783 | 5.3% |
| 13 | 750 | 5.1% |
| 12 | 747 | 5.1% |
| 21 | 740 | 5.0% |
| 22 | 740 | 5.0% |
| 17 | 722 | 4.9% |
| 14 | 712 | 4.8% |
| 20 | 703 | 4.8% |
| 25 | 695 | 4.7% |
| Other values (12) | 7404 |
| Value | Count | Frequency (%) |
| 1 | 600 | |
| 2 | 549 | |
| 3 | 627 | |
| 12 | 747 | |
| 13 | 750 | |
| 14 | 712 | |
| 15 | 783 | |
| 16 | 616 | |
| 17 | 722 | |
| 18 | 791 |
| Value | Count | Frequency (%) |
| 30 | 506 | |
| 29 | 605 | |
| 28 | 605 | |
| 27 | 650 | |
| 26 | 683 | |
| 25 | 695 | |
| 24 | 658 | |
| 23 | 631 | |
| 22 | 740 | |
| 21 | 740 |
trip_dayofweek
Real number (ℝ)
Zeros 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9209441 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 1980 |
| Zeros (%) | 13.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 115.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.9276895 |
|---|---|
| Coefficient of variation (CV) | 0.65995428 |
| Kurtosis | -1.1685046 |
| Mean | 2.9209441 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.065904383 |
| Sum | 43192 |
| Variance | 3.715987 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 2731 | |
| 5 | 2128 | |
| 3 | 2103 | |
| 4 | 2057 | |
| 1 | 2035 | |
| 0 | 1980 | |
| 6 | 1753 |
| Value | Count | Frequency (%) |
| 0 | 1980 | |
| 1 | 2035 | |
| 2 | 2731 | |
| 3 | 2103 | |
| 4 | 2057 | |
| 5 | 2128 | |
| 6 | 1753 |
| Value | Count | Frequency (%) |
| 6 | 1753 | |
| 5 | 2128 | |
| 4 | 2057 | |
| 3 | 2103 | |
| 2 | 2731 | |
| 1 | 2035 | |
| 0 | 1980 |
Interactions
Correlations
| actual_distance_to_destination | actual_time | dest_state | od_time_diff_hour | osrm_distance | osrm_time | route_type | segment_actual_time_sum | segment_osrm_distance_sum | segment_osrm_time_sum | source_state | start_scan_to_end_scan | trip_day | trip_dayofweek | trip_hour | trip_month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| actual_distance_to_destination | 1.000 | 0.903 | 0.169 | 0.840 | 0.991 | 0.979 | 0.528 | 0.902 | 0.984 | 0.968 | 0.138 | 0.841 | -0.004 | 0.002 | 0.085 | 0.033 |
| actual_time | 0.903 | 1.000 | 0.145 | 0.897 | 0.911 | 0.906 | 0.474 | 1.000 | 0.910 | 0.902 | 0.121 | 0.898 | 0.001 | -0.006 | 0.024 | 0.020 |
| dest_state | 0.169 | 0.145 | 1.000 | 0.157 | 0.178 | 0.191 | 0.454 | 0.142 | 0.158 | 0.162 | 0.750 | 0.152 | 0.022 | 0.000 | 0.153 | 0.035 |
| od_time_diff_hour | 0.840 | 0.897 | 0.157 | 1.000 | 0.848 | 0.843 | 0.527 | 0.897 | 0.845 | 0.837 | 0.129 | 0.995 | 0.013 | 0.005 | 0.063 | 0.032 |
| osrm_distance | 0.991 | 0.911 | 0.178 | 0.848 | 1.000 | 0.990 | 0.518 | 0.910 | 0.991 | 0.979 | 0.141 | 0.849 | -0.003 | 0.002 | 0.083 | 0.031 |
| osrm_time | 0.979 | 0.906 | 0.191 | 0.843 | 0.990 | 1.000 | 0.561 | 0.904 | 0.984 | 0.990 | 0.143 | 0.845 | -0.004 | 0.003 | 0.086 | 0.029 |
| route_type | 0.528 | 0.474 | 0.454 | 0.527 | 0.518 | 0.561 | 1.000 | 0.472 | 0.476 | 0.508 | 0.404 | 0.507 | 0.043 | 0.030 | 0.152 | 0.027 |
| segment_actual_time_sum | 0.902 | 1.000 | 0.142 | 0.897 | 0.910 | 0.904 | 0.472 | 1.000 | 0.909 | 0.901 | 0.120 | 0.898 | 0.001 | -0.006 | 0.024 | 0.020 |
| segment_osrm_distance_sum | 0.984 | 0.910 | 0.158 | 0.845 | 0.991 | 0.984 | 0.476 | 0.909 | 1.000 | 0.989 | 0.122 | 0.846 | -0.003 | 0.002 | 0.081 | 0.032 |
| segment_osrm_time_sum | 0.968 | 0.902 | 0.162 | 0.837 | 0.979 | 0.990 | 0.508 | 0.901 | 0.989 | 1.000 | 0.127 | 0.839 | -0.004 | 0.003 | 0.081 | 0.033 |
| source_state | 0.138 | 0.121 | 0.750 | 0.129 | 0.141 | 0.143 | 0.404 | 0.120 | 0.122 | 0.127 | 1.000 | 0.127 | 0.027 | 0.000 | 0.144 | 0.036 |
| start_scan_to_end_scan | 0.841 | 0.898 | 0.152 | 0.995 | 0.849 | 0.845 | 0.507 | 0.898 | 0.846 | 0.839 | 0.127 | 1.000 | 0.012 | 0.005 | 0.064 | 0.033 |
| trip_day | -0.004 | 0.001 | 0.022 | 0.013 | -0.003 | -0.004 | 0.043 | 0.001 | -0.003 | -0.004 | 0.027 | 0.012 | 1.000 | 0.304 | -0.009 | 1.000 |
| trip_dayofweek | 0.002 | -0.006 | 0.000 | 0.005 | 0.002 | 0.003 | 0.030 | -0.006 | 0.002 | 0.003 | 0.000 | 0.005 | 0.304 | 1.000 | -0.028 | 0.408 |
| trip_hour | 0.085 | 0.024 | 0.153 | 0.063 | 0.083 | 0.086 | 0.152 | 0.024 | 0.081 | 0.081 | 0.144 | 0.064 | -0.009 | -0.028 | 1.000 | 0.021 |
| trip_month | 0.033 | 0.020 | 0.035 | 0.032 | 0.031 | 0.029 | 0.027 | 0.020 | 0.032 | 0.033 | 0.036 | 0.033 | 1.000 | 0.408 | 0.021 | 1.000 |
Missing values
Sample
| trip_uuid | trip_creation_time | route_schedule_uuid | route_type | start_scan_to_end_scan | actual_distance_to_destination | actual_time | osrm_time | osrm_distance | segment_actual_time_sum | segment_osrm_time_sum | segment_osrm_distance_sum | od_time_diff_hour | dest_state | dest_city | dest_place | dest_code | source_state | source_city | source_place | source_code | trip_month | trip_hour | trip_day | trip_dayofweek | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | trip-153671041653548748 | 2018-09-12 00:00:16.535741 | thanos::sroute:d7c989ba-a29b-4a0b-b2f4-288cdc60074b | FTL | 2259.0 | 824.732854 | 1562.0 | 717.0 | 991.3523 | 1548.0 | 1008.0 | 1320.4733 | 2260.109800 | uttar pradesh | kanpur | central | 6 | madhya pradesh | bhopal | trnsport | h | 9 | 0 | 12 | 2 |
| 1 | trip-153671042288605164 | 2018-09-12 00:00:22.886430 | thanos::sroute:3a1b0ab2-bb0b-4c53-8c59-eb2a2c0d68b9 | Carting | 180.0 | 73.186911 | 143.0 | 68.0 | 85.1110 | 141.0 | 65.0 | 84.1894 | 181.611874 | karnataka | doddablpur | chikadpp | d | karnataka | tumkur | veersagr | i | 9 | 0 | 12 | 2 |
| 2 | trip-153671043369099517 | 2018-09-12 00:00:33.691250 | thanos::sroute:de5e208e-7641-45e6-8100-4d9fb1e5720d | FTL | 3933.0 | 1927.404273 | 3347.0 | 1740.0 | 2354.0665 | 3308.0 | 1941.0 | 2545.2678 | 3934.362520 | haryana | gurgaon | bilaspur | hb | karnataka | bangalore | nelmngla | h | 9 | 0 | 12 | 2 |
| 3 | trip-153671046011330457 | 2018-09-12 00:01:00.113710 | thanos::sroute:f0176492-a679-4597-8332-bbd1c7f9f442 | Carting | 100.0 | 17.175274 | 59.0 | 15.0 | 19.6800 | 59.0 | 16.0 | 19.8766 | 100.494935 | maharashtra | mumbai | mirard | ip | maharashtra | mumbai hub | mumbai | none | 9 | 0 | 12 | 2 |
| 4 | trip-153671052974046625 | 2018-09-12 00:02:09.740725 | thanos::sroute:d9f07b12-65e0-4f3b-bec8-df0613461b0f | FTL | 717.0 | 127.448500 | 341.0 | 117.0 | 146.7918 | 340.0 | 115.0 | 146.7919 | 718.349042 | karnataka | hospet | hospet | none | karnataka | bellary | bellary | dc | 9 | 0 | 12 | 2 |
| 5 | trip-153671055416136166 | 2018-09-12 00:02:34.161600 | thanos::sroute:9bf03170-d0a2-4a3f-aa4d-9aaab3d98af4 | Carting | 189.0 | 24.597048 | 61.0 | 23.0 | 28.0647 | 60.0 | 23.0 | 28.0647 | 190.487849 | tamil nadu | chennai | chennai | poonamallee | tamil nadu | chennai | porur | dpc | 9 | 0 | 12 | 2 |
| 6 | trip-153671066201138152 | 2018-09-12 00:04:22.011653 | thanos::sroute:a97698cc-846e-41a7-916b-88b17412610c | Carting | 98.0 | 9.100510 | 24.0 | 13.0 | 12.0184 | 24.0 | 13.0 | 12.0184 | 98.005634 | tamil nadu | chennai | vandalur | dc | tamil nadu | chennai | chrompet | dpc | 9 | 0 | 12 | 2 |
| 7 | trip-153671066826362165 | 2018-09-12 00:04:28.263977 | thanos::sroute:d5b71ae9-a11a-4f52-bcb7-274b65e2c513 | Carting | 146.0 | 22.424210 | 64.0 | 34.0 | 28.9203 | 64.0 | 34.0 | 28.9203 | 176.448324 | karnataka | bengaluru | nwylhnka | dc | karnataka | hbr layout pc | hbr | none | 9 | 0 | 12 | 2 |
| 8 | trip-153671074033284934 | 2018-09-12 00:05:40.333071 | thanos::sroute:a0e60427-16ad-4b17-b3b0-6a0664355ae1 | Carting | 280.0 | 25.454848 | 161.0 | 29.0 | 30.9359 | 161.0 | 29.0 | 30.9358 | 310.804135 | gujarat | surat | central | 3 | gujarat | surat | central | 4 | 9 | 0 | 12 | 2 |
| 9 | trip-153671079956500691 | 2018-09-12 00:06:39.565253 | thanos::sroute:a10888ff-f794-41e1-9b7a-7f62ef663dda | Carting | 49.0 | 9.872146 | 23.0 | 8.0 | 9.9566 | 23.0 | 14.0 | 16.0860 | 49.333390 | delhi | delhi | delhi | bhogal | delhi | delhi | lajpat | ip | 9 | 0 | 12 | 2 |
| trip_uuid | trip_creation_time | route_schedule_uuid | route_type | start_scan_to_end_scan | actual_distance_to_destination | actual_time | osrm_time | osrm_distance | segment_actual_time_sum | segment_osrm_time_sum | segment_osrm_distance_sum | od_time_diff_hour | dest_state | dest_city | dest_place | dest_code | source_state | source_city | source_place | source_code | trip_month | trip_hour | trip_day | trip_dayofweek | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14777 | trip-153861089403973335 | 2018-10-03 23:54:54.039992 | thanos::sroute:233c5ce2-a1e2-4550-945c-28c357cafe57 | Carting | 98.0 | 33.898361 | 49.0 | 27.0 | 36.4426 | 48.0 | 40.0 | 50.0725 | 98.726590 | gujarat | anand | vaghasi | ip | gujarat | vadodara | karelibaug | dpc | 10 | 23 | 3 | 2 |
| 14778 | trip-153861089559302126 | 2018-10-03 23:54:55.593290 | thanos::sroute:9c1c7ad6-d0e4-4077-b574-4ab11de60bc1 | Carting | 186.0 | 28.114091 | 86.0 | 30.0 | 34.9224 | 86.0 | 30.0 | 34.9223 | 231.326709 | maharashtra | mumbai | ulhasngr | dc | maharashtra | mumbai | east | 21 | 10 | 23 | 3 | 2 |
| 14779 | trip-153861089872028474 | 2018-10-03 23:54:58.720536 | thanos::sroute:27463ea7-5903-4530-92e7-6a4feca7b07c | Carting | 181.0 | 27.010926 | 62.0 | 28.0 | 38.2867 | 61.0 | 33.0 | 33.6400 | 182.416663 | tamil nadu | chennai | vepmpttu | dc | tamil nadu | chennai | porur | dpc | 10 | 23 | 3 | 2 |
| 14780 | trip-153861090163768194 | 2018-10-03 23:55:01.637939 | thanos::sroute:9bf03170-d0a2-4a3f-aa4d-9aaab3d98af4 | Carting | 58.0 | 15.135009 | 42.0 | 12.0 | 15.8436 | 41.0 | 11.0 | 15.8436 | 58.171907 | tamil nadu | chennai | sriperumbudur | dc | tamil nadu | chennai | chennai | poonamallee | 10 | 23 | 3 | 2 |
| 14781 | trip-153861091843037040 | 2018-10-03 23:55:18.430664 | thanos::sroute:f0176492-a679-4597-8332-bbd1c7f9f442 | Carting | 88.0 | 17.760248 | 38.0 | 16.0 | 20.5065 | 37.0 | 16.0 | 20.5065 | 88.215987 | maharashtra | mumbai | mirard | ip | maharashtra | mumbai hub | mumbai | none | 10 | 23 | 3 | 2 |
| 14782 | trip-153861095625827784 | 2018-10-03 23:55:56.258533 | thanos::sroute:8a120994-f577-4491-9e4b-b7e4a1479d2f | Carting | 257.0 | 57.762332 | 83.0 | 62.0 | 73.4630 | 82.0 | 62.0 | 64.8551 | 405.485842 | punjab | zirakpur | zirakpur | dc | punjab | chandigarh | mehmdpur | h | 10 | 23 | 3 | 2 |
| 14783 | trip-153861104386292051 | 2018-10-03 23:57:23.863155 | thanos::sroute:b30e1ec3-3bfa-4bd2-a7fb-3b757695fc1a | Carting | 60.0 | 15.513784 | 21.0 | 12.0 | 16.0882 | 21.0 | 11.0 | 16.0883 | 60.590521 | haryana | faridabad | blbgarh | dc | haryana | fbd | balabhgarh | dpc | 10 | 23 | 3 | 2 |
| 14784 | trip-153861106442901555 | 2018-10-03 23:57:44.429324 | thanos::sroute:5609c268-e436-4e0a-8180-3db4a743161e | Carting | 421.0 | 38.684839 | 282.0 | 48.0 | 58.9037 | 281.0 | 88.0 | 104.8866 | 422.119867 | uttar pradesh | kanpur | govndngr | dc | uttar pradesh | kanpur | central | 6 | 10 | 23 | 3 | 2 |
| 14785 | trip-153861115439069069 | 2018-10-03 23:59:14.390954 | thanos::sroute:c5f2ba2c-8486-4940-8af6-d1d2a6a37a00 | Carting | 347.0 | 134.723836 | 264.0 | 179.0 | 171.1103 | 258.0 | 221.0 | 223.5324 | 348.512862 | tamil nadu | eral | busstand | d | tamil nadu | tirunelveli | vdkkusrt | i | 10 | 23 | 3 | 2 |
| 14786 | trip-153861118270144424 | 2018-10-03 23:59:42.701692 | thanos::sroute:412fea14-6d1f-4222-8a5f-a5170425649b | FTL | 353.0 | 66.081533 | 275.0 | 68.0 | 80.5787 | 274.0 | 67.0 | 80.5787 | 354.407571 | karnataka | sandur | wrdn1dpp | d | karnataka | hospet | hospet | none | 10 | 23 | 3 | 2 |